Assessor Resource

ICTPRG555
Implement Object Relational Mapping Framework for data persistence

Assessment tool

Version 1.0
Issue Date: May 2024


This unit describes the skills and knowledge required to implement an Object Relational Mapping (ORM) framework to map, retrieve and manage object persistence in any programming language.

The unit applies to those working as senior software developers, senior back end developers or full stack developers, and responsible for managing Information and Communications Technology (ICT) in small-to-large enterprises (SMEs).

No licensing, legislative or certification requirements apply to this unit at the time of publication.

You may want to include more information here about the target group and the purpose of the assessments (eg formative, summative, recognition)


Evidence Required

List the assessment methods to be used and the context and resources required for assessment. Copy and paste the relevant sections from the evidence guide below and then re-write these in plain English.

The candidate must demonstrate the ability to complete the tasks outlined in the elements, performance criteria and foundation skills of this unit, including evidence of the ability to:

use ORM framework to handle at least two different transactions

use ORM framework to manage data persistence to create, update, read and delete operation at least once

use ORM framework to handle concurrency when working with data persistence

confirm and use commands affecting at least two entities to the data source.

The candidate must be able to demonstrate knowledge to complete the tasks outlined in the elements, performance criteria and foundation skills of this unit, including knowledge of:

functions, features and uses of a database and selected data store

language used in object-oriented (OO) programming

different ORM framework methodologies, including:

database first methodology

object first methodology

functions and features of an ORM framework

testing techniques used for ORM framework

functions and features of transactions, commits and rollbacks

lazy and eager loading or persistent data objects

function and use of concurrency

testing processes for transaction success.

Skills in this unit must be demonstrated in a workplace or simulated environment where the conditions are typical of those in a working environment in this industry.

This includes access to:

integrated development environment (IDE) required to use ORM frameworks

the internet, including connectivity

hardware, software and applications required for the performance evidence.

Assessors of this unit must satisfy the requirements for assessors in applicable vocational education and training legislation, frameworks and/or standards.

Submission Requirements

List each assessment task's title, type (eg project, observation/demonstration, essay, assingnment, checklist) and due date here

Assessment task 1: [title]      Due date:

(add new lines for each of the assessment tasks)

Assessment Tasks

Copy and paste from the following data to produce each assessment task. Write these in plain English and spell out how, when and where the task is to be carried out, under what conditions, and what resources are needed. Include guidelines about how well the candidate has to perform a task for it to be judged satisfactory.

The candidate must demonstrate the ability to complete the tasks outlined in the elements, performance criteria and foundation skills of this unit, including evidence of the ability to:

use ORM framework to handle at least two different transactions

use ORM framework to manage data persistence to create, update, read and delete operation at least once

use ORM framework to handle concurrency when working with data persistence

confirm and use commands affecting at least two entities to the data source.

The candidate must be able to demonstrate knowledge to complete the tasks outlined in the elements, performance criteria and foundation skills of this unit, including knowledge of:

functions, features and uses of a database and selected data store

language used in object-oriented (OO) programming

different ORM framework methodologies, including:

database first methodology

object first methodology

functions and features of an ORM framework

testing techniques used for ORM framework

functions and features of transactions, commits and rollbacks

lazy and eager loading or persistent data objects

function and use of concurrency

testing processes for transaction success.

Skills in this unit must be demonstrated in a workplace or simulated environment where the conditions are typical of those in a working environment in this industry.

This includes access to:

integrated development environment (IDE) required to use ORM frameworks

the internet, including connectivity

hardware, software and applications required for the performance evidence.

Assessors of this unit must satisfy the requirements for assessors in applicable vocational education and training legislation, frameworks and/or standards.
Copy and paste from the following performance criteria to create an observation checklist for each task. When you have finished writing your assessment tool every one of these must have been addressed, preferably several times in a variety of contexts. To ensure this occurs download the assessment matrix for the unit; enter each assessment task as a column header and place check marks against each performance criteria that task addresses.

Observation Checklist

Tasks to be observed according to workplace/college/TAFE policy and procedures, relevant legislation and Codes of Practice Yes No Comments/feedback
Instantiate single object in domain model and persist in data store according to ORM framework 
Instantiate collection of objects in domain model and persist in data store according to ORM framework 
Retrieve objects from data store 
Update object and persist changes back to data store using ORM framework 
Delete data in data store 
Detach data and reattach data 
Implement eager loading of related domain 
Implement lazy loading of related domain objects 
Handle transaction commits and rollbacks effectively according to ORM framework and business needs 
Handle data persistence and concurrency effectively according to ORM framework and business needs 
Implement and confirm error-handling 
Test and confirm transaction success according to business needs 

Forms

Assessment Cover Sheet

ICTPRG555 - Implement Object Relational Mapping Framework for data persistence
Assessment task 1: [title]

Student name:

Student ID:

I declare that the assessment tasks submitted for this unit are my own work.

Student signature:

Result: Competent Not yet competent

Feedback to student

 

 

 

 

 

 

 

 

Assessor name:

Signature:

Date:

Assessment Record Sheet

ICTPRG555 - Implement Object Relational Mapping Framework for data persistence

Student name:

Student ID:

Assessment task 1: [title] Result: Competent Not yet competent

(add lines for each task)

Feedback to student:

 

 

 

 

 

 

 

 

Overall assessment result: Competent Not yet competent

Assessor name:

Signature:

Date:

Student signature:

Date: